Supplier (inbound) invoice processing

This section provides an overview of the entire e-invoicing inbound process. Remember that not all functionality is in place while development continues.

Process overview

Supplier invoice processing

1. The document, such as an invoice or a credit memo, is sent by the supplier via the Sage Network or as an attachment to a dedicated email address.

2. The document passes through the inbound gateway and is processed according to its file type and origin:
   • Attachments are extracted from emails.
   • XML files are extracted in a hybrid format such as Facture-X or ZUGFeRD.
   • Optical character recognition (OCR) is used for PDFs and images.
   • Header and footer information in structured XML files are parsed.
3. Header information, like supplier name, site, and so on, are mapped data in Sage X3.
4. The supplier e-invoice is generated in the relevant module, Purchasing or A/P-A/R accounting.

Receive invoices from Sage Network

Open: Declarations > E-invoicing > Receiving > Collect invoices

The functionality mentioned in this section is specifically for supplier invoices received through Sage Network. At this release, it applies to French and Spanish legislations.

Get inbound invoices

Use this function to collect supplier invoices received in Sage Network that have not yet been synchronized with Sage X3. You can define a set of criteria to filter invoices to collect and you can set up a batch task to run the process on a regular basis.

Display inbound invoices

Use this function to display supplier invoices collected with Get inbound invoices. It is intended for administrators to view details for collected supplier invoices such as:

• The origin and details like supplier name, recipient, amounts, and so on.
• The partial parsing results performed by Sage X3 before the transaction was created in the import buffer.

Receive invoices by email or directory

Open: Declarations > Sage Network > AP Automation

These functions are part of the AP Automation process uses Sage AI to scan documents and return results mapped to existing Sage X3 values. Before generating the invoice in the final step, you can review and modify values as needed.

Process documents

Use this function to process supplier invoices created from the email inbox associated with the company. You can also manually create a new incoming invoice saved to a directory.

Get emails

Use this function to process documents sent to the AP Automation email, that was created when you registered your company. Documents are processed using 2 different bulk actions to get attachments and then scan documents.

Scan documents

Use this function to digitize invoices in PDF, image, or other formats retrieved from previously described processes. You can set up a batch task to run the process on a regular basis.

Send feedback

Use this function to send feedback to Sage AI so that it can learn and improve results.

When you run this process for a company or companies, a JSON file is created that contains validated data used to post invoices. The JSON file is sent to Sage AI. You can run this process at any time or set up a batch task.

The file only contains partial data of posted invoices created through the AP Automation process. Invoices created outside of the AP Automation process are not included, even if the company is registered.

Send supplier details

Use this function to send supplier details to Sage AI to improve results for processed documents. The data sent will be used in release 2025.R2 to match the supplier extracted from the document, such as a PDF or XML file, with the supplier details available in the Sage AI directory for the onboarded company.

The process generates a JSON file that contains supplier details for companies registered with Sage AI.

Supplier e-invoice mapping

Open: Declarations > E-invoicing > Receiving > Supplier e-invoice mapping

The objective of this function is to drive, when possible, the automatic determination of the Sage X3 data from the XML. For example, the determination of the Sage X3 supplier from the supplier’s name, tax ID, or the EU tax number.

Remember that this process assumes that inbound e-invoices were collected by Sage X3 from Sage Network.

For each inbound e-invoice, Sage X3 creates a record in the temporary table using properties parsed from the XML file using the XML designer. The initial status is To be mapped.

The standard process is not completely automated. The objective is to initiate the creation of the invoices, in the relevant module, with their header and a generic line. You need to complete the transaction using the current process. For AP invoices, allocate amounts to different accounts and/or dimensions. In the Purchasing module, reconcile with receipts, orders, or invoices. 

If the mapping is not successful, the record status of the record changes from To be mapped to Incomplete mapping, and you need resolve the issues. If the mapping is successful, either completed automatically or manually, the record status changes to Mapped, and the record is ready for the next step, which is creating the invoice in the relevant module.

Mapping rules

Mapping rules rely on the following information, which is required to create the e-invoice.

Property	Determination
PO number	Directly extracted from the XML file header. If the purchase order is found in the Purchasing module, it enables automatic determination of the company, site, and supplier.
Company	Sage X3 code from the company name, the tax ID and the EU VAT no. in the XML file. Settings are available to manage duplicates.
Site	Sage X3 code the site name, the tax ID, or the EU VAT no. in the XML file. Settings are available to manage duplicates.
Supplier	From the supplier name, the tax ID, or the EU VAT no. in the XML file. Settings are available to manage duplicates.
Module	From settings associated with the supplier.
Date	Date record was created in the temporary table.
Currency	Retrieved from the ISO code in the XML file.
Invoice type	From the supplier invoice type.
Supplier invoice date	Directly parsed from the XML file.
Supplier invoice no.	Directly parsed from the XML file. If the invoice already exists in the Purchasing module, invoice creation is blocked. For intercompany transactions, the invoice is linked to the Sage X3transaction, and its creation is blocked. If the amounts do not match, you need to take action.
Tax excl. amount	Directly parsed from the XML file.
Tax amount	Directly parsed from the XML file
Tax incl. amount	Directly parsed from the XML file

You can define how duplicates are managed. For example, 2 different suppliers in Sage X3 match identifiers in the XML, you can accept the first result the system finds or trigger an error.

Supplier e-invoice generation

Open: Declarations > E-invoicing > Receiving > Supplier e-invoice generation

The inbound e-invoice process, from the retrieving of e-invoices from the Sage Network up to creating e-invoices, rely on the temporary tables. First, you select the e-invoices you want to see and act on.

You can:

• Get lists of e-invoices and access to the attached documents.

• Complete the mapping if not done.

• Trigger the generation of the invoices. For this generation, the import/export templates used are EINVBISIMP for AP invoices, and EINVPIHIMP for Purchasing invoices.

You can restrict access to a subset of sites and/or companies using the standard functional rights. The generation of the invoices can be run manually or automatically using recurring tasks on a custom schedule. Only e-invoices that are fully mapped are processed.